package com.yonyou.pmclouds.safeinspection.mapper;

import com.yonyou.pmclouds.basecom.dao.BaseMapper;
import com.yonyou.pmclouds.safeinspection.entity.SafeInspectionListVO;
import com.yonyou.pmclouds.safeinspection.entity.SafeInspectionVO;
import org.apache.ibatis.annotations.ResultMap;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author 徐老板
 * @date 2020/4/21   14:06
 */
public interface SafeinspectionMapper extends BaseMapper<SafeInspectionVO> {

    @Select("select * from pm_safeinspection where pk_project=#{pk_project} and dr=0 order by creationtime desc")
    @ResultMap("viewmap")
    List<SafeInspectionListVO> selectByProjectId(String pk_project);

}
